<?php
include "db.php";
$state=$_REQUEST['estado'];
echo "<table align='center'>
		<tr>
			<td>Club:</td>
			<td>";
				$sql="SELECT * FROM  st_club WHERE  estado_id =  '$state' AND statuss != 'a'";
				$result = mysql_query($sql) or die( mysql_error());	
				echo"<select name='club' id='club'>";
				while ($fila = mysql_fetch_assoc($result)) {
				echo"<option value='". $fila['club_number'] ."'>". $fila['club_name'] ."</option>";
				}
				echo"</select>";
echo"</td><tr></table>";
?>
<center><div id="ajax2"></div></center>
<script type="text/javascript" >
$(function () {
		$('#club').click(function()
	{
		$('#ajax2').load('add_club3.php?club=' + this.options[this.selectedIndex].value)
	})	
})
</script>